<?php
require("../../inc/header.php");

/*
		SoftName : EmpireBak Version 2010
		Author   : wm_chief
		Copyright: Powered by www.phome.net
*/

DoSetDbChar('utf8');
E_D("DROP TABLE IF EXISTS `ecs_attribute`;");
E_C("CREATE TABLE `ecs_attribute` (
  `attr_id` smallint(5) unsigned NOT NULL auto_increment,
  `cat_id` smallint(5) unsigned NOT NULL default '0',
  `attr_name` varchar(60) NOT NULL default '',
  `attr_input_type` tinyint(1) unsigned NOT NULL default '1',
  `attr_type` tinyint(1) unsigned NOT NULL default '1',
  `attr_values` text NOT NULL,
  `attr_index` tinyint(1) unsigned NOT NULL default '0',
  `sort_order` tinyint(3) unsigned NOT NULL default '0',
  `is_linked` tinyint(1) unsigned NOT NULL default '0',
  `attr_group` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`attr_id`),
  KEY `cat_id` (`cat_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8");
E_D("replace into `ecs_attribute` values('1','1','颜色','1','1','黑色\r\n白色\r\n灰色\r\n蓝色\r\n黄色\r\n','0','0','0','0');");
E_D("replace into `ecs_attribute` values('2','1','版本','1','1','60G\r\n120G\r\n320G\r\n单核\r\n双核\r\nWIN8\r\nWIN7\r\nWINXP','0','0','0','0');");
E_D("replace into `ecs_attribute` values('3','2','颜色','1','1','红色\r\n蓝色\r\n白色\r\n黑色\r\n灰色\r\n米色\r\n青色','0','0','0','0');");
E_D("replace into `ecs_attribute` values('4','2','尺寸','1','1','M\r\nX\r\nXL\r\nXXL\r\nXXXL','0','0','0','0');");

require("../../inc/footer.php");
?>